﻿-- 班组人员信息
CREATE procedure [dbo].[GroupRyInfo_Get]
@bzid varchar(20) = null,
@sfzh varchar(18) = null,
@xm varchar(10)= null
as
select sfzh,xm,bzmc
from vRyBzInfo
where (@bzid is null or (isnull(bzid,'-1') like @bzid+'%'))
and (@sfzh is null or sfzh like @sfzh+'%')
and (@xm is null or xm like '%'+@xm+'%')